package com.example.qxfw.hbqx.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.qxfw.common.entity.zy.AirpolLiveQx;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
@DS("service")
public interface AirpolLiveQxMapper extends BaseMapper<AirpolLiveQx> {
    /**
     * 降序获取观测时间
     * @return
     */
    @Select("SELECT observtime " +
            "FROM airpol_live_qx " +
            "ORDER BY observtime DESC " +
            "LIMIT 1 ")
    List<AirpolLiveQx> getObservtime();
}
